#from  sqlalchemy import  create_engine
import pymysql
import  pandas as pd
#engine = create_engine("mysql+pymysql://admin:Root123456!@192.168.18.76:3306/hrdata?charset=utf8")

#formlist = pd.read_sql_query("show tables",con=engine)
#print("hrdata数据库表清单为: \n",formlist)

conn = pymysql.connect(host="192.168.18.76",
                       port=3306,
                       user="admin",
                       passwd="Root123456!",
                       db="hrdata",
                       charset="utf8")
formlist = pd.read_sql_query("show tables",con=conn)
print('hrdata数据库表清单为： \n',formlist)
